﻿CREATE PROCEDURE [dbo].[JobUpdate]
(@JobID UniqueIdentifier,
@RunID UniqueIdentifier,
@ComponentID UniqueIdentifier,
@Dependency varchar(500),
@IsFirstJob bit,
@IsLastJob bit,
@HasError bit,
@Cancelled bit,
@Priority int,
@SubmitTime datetime,
@ReceiveTime datetime,
@StartTime datetime,
@FinishTime datetime)
AS begin
	update Job set
		RunID=@RunID,
		ComponentID=@ComponentID,
		Dependency=@Dependency,
		IsFirstJob=@IsFirstJob,
		IsLastJob=@IsLastJob,
		HasError=@HasError,
		Cancelled=@Cancelled,
		Priority=@Priority,
		SubmitTime=@SubmitTime,
		ReceiveTime=@ReceiveTime,
		StartTime=@StartTime,
		FinishTime=@FinishTime
	where
		JobID=@JobID;
end